| Key Name |
Key Type |
Keys |
| CmEventHistory_ro_CmTemplateID_N_N_IDX |
Inversion Entry |
TaskTemplateId |
| CmEventHistory_ro_CmEventID_U_C_IDX |
PrimaryKey |
TaskArchiveId |
| NK_CmEventHistory_roPlEmployerContactID |
Inversion Entry |
EmployerContactId |
| NK_CmEventHistory_roPrevSyStaffID |
Inversion Entry |
PreviouslyAssignedToStaffId |
| CmEventHistory_ro_SyOrganizationContactID_N_N_IDX |
Inversion Entry |
SyOrganizationContactID |
| CmEventHistory_ro_SyOrganizationID_N_N_IDX |
Inversion Entry |
SyOrganizationID |
| CmEventHistory_ro_SetupBy_N_N_IDX |
Inversion Entry |
CreatedByStaffId |
| CmEventHistory_ro_CmEventResultID_N_N_IDX |
Inversion Entry |
TaskResultId |
| CmEventHistory_ro_CmTemplateID_CmEventStatusID_DueDate_N_N_IDX |
Inversion Entry |
TaskTemplateId, TaskStatusId, TaskDueDate |
| CmEventHistory_ro_DueDate_N_N_IDX |
Inversion Entry |
TaskDueDate |
| CmEventHistory_ro_CmEventTypeID_N_N_IDX |
Inversion Entry |
TaskTypeId |
| CmEventHistory_ro_CmEventStatusID_N_N_IDX |
Inversion Entry |
TaskStatusId |
| NK_CmEventHistory_roSessionSyCampusID |
Inversion Entry |
SessionSyCampusID |
| NK_CmEventHistory_roCmAttachmentsId |
Inversion Entry |
AttachmentId |
| CmEventHistory_ro_CmEventStatusID_DueDate_N_N_IDX |
Inversion Entry |
TaskStatusId, TaskDueDate |
| CmEventHistory_ro_CmTemplateID_CmEventStatusID_DueDate_SyStudentID_PlEmployerID_N_N_IDX |
Inversion Entry |
TaskTemplateId, TaskStatusId, TaskDueDate |
| CmEventHistory_ro_SyStaffID_N_N_IDX |
Inversion Entry |
StaffId |
| Entity Name |
Type |
Cardinality |
Business Name |
VerbPhrase |
InversePhrase |
Foreign Keys |
Is Supertype |
| Staff |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StaffId |
NO |
| Attachment |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
AttachmentId |
NO |
| EmployerContact |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
EmployerContactId |
NO |
| Campus |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
SessionSyCampusID |
NO |
| Staff |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StaffId |
NO |
| Staff |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StaffId |
NO |
| Employer |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
EmployerId |
NO |
| EmployerJob |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
PlEmployerJobID |
NO |
| TaskResult |
Non-Identifying |
One To Zero or More |
|
|
|
TaskResultId |
NO |
| TaskStatus |
Non-Identifying |
One To Zero or More |
|
|
|
TaskStatusId |
NO |
| TaskType |
Non-Identifying |
One To Zero or More |
|
|
|
TaskTypeId |
NO |
| TaskTemplate |
Non-Identifying |
One To Zero or More |
|
|
|
TaskTemplateId |
NO |
| SyOrganizationContact |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
SyOrganizationContactID |
NO |
| SyOrganization |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
SyOrganizationID |
NO |
| Staff |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
PreviouslyAssignedToStaffId |
NO |
| Staff |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StaffId |
NO |
| ProspectInquiry |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
ProspectInquiryId |
NO |
| Student |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentId |
NO |
| StudentEnrollmentPeriod |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentEnrollmentPeriodId |
NO |
| SyOrganization |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
SyOrganizationID |
NO |
| SyOrganizationContact |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
SyOrganizationContactID |
NO |
| TaskResult |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
TaskResultId |
NO |
| TaskStatus |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
TaskStatusId |
NO |
| TaskTemplate |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
TaskTemplateId |
NO |
| TaskType |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
TaskTypeId |
NO |